-- 创建导出记录表
CREATE TABLE [dbo].[export_record] (
  [id] int IDENTITY(1,1) NOT NULL,
  [username] nvarchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [accid] int NOT NULL,
  [export_time] datetime DEFAULT GETDATE() NOT NULL,
  [syNumbers] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
  [dateOption] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
  [fileNames] nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
  CONSTRAINT [PK_export_record] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[export_record] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键id',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'accid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'导出时间',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'export_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'导出试样号',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'syNumbers'
GO

EXEC sp_addextendedproperty
'MS_Description', N'选择日期',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'dateOption'
GO

EXEC sp_addextendedproperty
'MS_Description', N'文件名',
'SCHEMA', N'dbo',
'TABLE', N'export_record',
'COLUMN', N'fileNames'
GO